Copyright: Copyright (C) 1995, Oracle Corporation
Citation: Copyright (C) 1995, Oracle Corporation


Oracle Backup and Recovery Help Contents

Step-by-step instructions

To back up the database in ARCHIVELOG mode

To back up the database in NO ARCHIVELOG mode

To back up the database when not running

To perform an automatic recovery

To restore from a full database backup

To restore a data file

To restore a control file

To review and modify database files for recovery

Dialog box reference

Backup Manager

Control File Recovery

Database Password Required

Database Files dialog box

Data File Recovery

Edit Database Parameters

Full Database Restoration

Recovery Manager


To back up the database in ARCHIVELOG mode

1	Open the Backup Manager.

The Backup Manager dialog appears.

2	When prompted, enter the database password and choose OK.

3	Select either Offline Full Database, Online Selected Tablespace, or Online Control File only, depending on what you want to back up.

4	Select either Tape or Disk as a destination for the backup file(s).

Note:  Backup to tape is not supported on all operating systems.

5	If you selected Disk in the previous step, specify a destination path either by using the Browse button or by typing the path in the Directory field.

6	Choose Backup to begin the backup procedure.

If you selected Offline Full Database, the database is automatically shut down by the backup process. A Backup Status dialog appears showing you how the backup is proceeding. Once the backup is complete, the database automatically restarts.


To back up the database in NO ARCHIVELOG mode

1	Open the Backup Manager.

The Backup Manager dialog appears.

2	When prompted, enter the database password and choose OK.

3	Select either Tape or Disk as a destination for the backup file(s).

Note:  Backup to tape is not supported on all operating systems.

4	If you selected Disk in the previous step, specify a destination path either by using the Browse button or by typing the path in the Directory field.

5	Choose Backup to begin the backup procedure.

The database is automatically shut down by the backup process. A Backup Status dialog appears, showing you how the backup is proceeding. Once the backup is complete, the database automatically re-starts.


To back up the database when not running

1	Open the Backup Manager.

The Backup Manager dialog appears.

2	Select either Tape or Disk as a destination for the backup file(s).

Note: Backup to tape is not supported on all operating systems.

3	If you selected Disk in the previous step, specify a destination path either by using the Browse button or by typing the path in the Directory field.

4	Choose Files to review and optionally modify the filenames of the database structure.

The Database Files dialog appears. The Data Files radio button is selected and these files are listed in the File List box.

5	Use the Filename box, the Add button, and the Remove button to define the list of data files in the database.

6	Select the Log Files radio button.

7	Use the Filename box, the Group Number box, the Add button, and the Remove button to define the list of log files in the database.

8	Select the Control Files radio button.

9	Use the Filename box, the Add button, and the Remove button to define the list of control files in the database.

10	 When finished, choose OK.

The Backup Manager dialog appears.

11	 Choose Backup to begin the backup procedure.

A Backup Status dialog appears, showing you how the backup is proceeding.


To perform an automatic recovery

1	Open the Recovery Manager.

The Recovery Manager dialog appears.

2	Select Automatic Recovery.

3	If the database is currently not running and you want to review and modify the filenames of the database structure, choose Files. The Database Files dialog appears. See To review and modify database files for recovery. Otherwise, skip to step 5.

4	If the database is currently not running and you want to change initialization parameters that will take effect once the database starts during the recovery process, choose Parameters. Otherwise, skip to the next step.

The Edit Database Parameters dialog appears.

5	Choose Recover.


To restore from a full database backup

1	Open the Recovery Manager.

The Recovery Manager dialog appears.

2	Select Restore From Full Database Backup

3	If the database is currently not running and you want to review and modify the filenames of the database structure, choose Files. See To review and modify database files for recovery.

4	If the database is currently not running and you want to change initialization parameters that will take effect once the database starts during the recovery process, choose Parameters.

The Edit Database Parameters dialog appears.

5	Choose Recover.

The Full Database Restoration dialog appears.

6	Select either Restore From Tape or Restore From Disk.

7	If you are restoring from tape, select the Device from which to restore from the dropdown list box. If you are restoring from disk, select the Directory from which to restore either by using the Browse button or typing the directory path in the Directory field.

8	Select the backup from which you want to restore files from the Backup dropdown list box. Selecting "<latest backup>" causes the Recovery Manager to use the latest backup in the directory you specified.

If the database is not running, you are prompted for your database password.

9	Enter your password and select OK.

10	 When finished, choose OK.


To restore a data file

1	Open the Recovery Manager.

The Recovery Manager dialog appears.

2	Select Restore Data File.

3	Select a data file to restore from the dropdown list box.

4	If the database is currently not running and you want to review and modify the filenames of the database structure, choose Files. See To review and modify database files for recovery.

5	If the database is currently not running and you want to change initialization parameters that will take effect once the database starts during the recovery process, choose Parameters. Otherwise, skip to the next step.

The Edit Database Parameters dialog appears.

6	Choose Recover.

7	Select either Restore from Tape, Restore From Disk, or Create a New Data File.

You would select Create a New Data File only if no data file backup exists. Go to step 9.

If you select Restore From Tape, select the tape Device from the dropdown list box. If you select Restore From Disk, select the directory from which to restore either by using the Browse button or by typing the directory path in the Directory field.

8	Select the backup from which you want to restore files from the Backup dropdown list box. Selecting "<latest backup>" causes the Recovery Manger to use the last known backup in the directory you specified.

9	When finished, choose OK.


To restore a control file

1	Open the Recovery Manager.

The Recovery Manager dialog appears.

2	Select Restore Control File.

3	If the database is currently not running and you want to review and modify the filenames of the database structure, choose Files. See To review and modify database files for recovery.

4	If you want to change initialization parameters that will take effect once the database starts during the recovery process, choose Parameters. Otherwise, skip to the next step.

The Edit Database Parameters dialog appears.

5	Choose Recover.

6	Select either Restore from Tape, Restore From Disk, or Create a New Control File.

You would select Create a New Data File only if no data file backup exists. Go to step 8.

If you select Restore From Tape, select the tape Device from the dropdown list box. If you select Restore From Disk, select the directory from which to restore either by using the Browse button or by typing the directory path in the Directory field.

7	Select the backup from which you want to restore files from the Backup dropdown list box. Selecting "<latest backup>" causes the Recovery Manger to use the last known backup in the directory you specified.

8	When finished, choose OK.


To review and modify database files for recovery

When the database is not running, the Files button is enabled. Since the database is not running, detailed information about the database structure is probably not available. However, accurate information will be available if you have previously used the Backup Manager or Recovery Manager while the database was running. When the database is running, Backup Manager or Recovery Manager reads and stores the structure of the database.

If the database is not running and you have not previously used Backup Manager or Recovery Manager with the database running, Recovery Manager reads the default values to determine the structure of the database.

To review and modify the filenames of the database structure, perform the following steps. (Note that the Files button is disabled if the database is running.)

1	Open the Recovery Manager.

The Recovery Manager dialog appears.

2	Choose Files.

The Database Files dialog appears. The Data Files radio button is selected and these files are listed in the File List box.

3	Use the Filename box, the Add button, and the Remove button to define the list of data files in the database.

4	Select the Log Files radio button.

5	Use the Filename box, the Group Number box, the Add button, and the Remove button to define the list of log files in the database.

6	Select the Control Files radio button.

7	Use the Filename box, the Add button, and the Remove button to define the list of control files in the database.

8	When finished, choose OK.

The Recovery Manager dialog appears.


Backup Manager dialog box

Use the Backup Manager to back up your Oracle7 database. The Backup Manager runs in two modes, depending upon the status of the database.

If the database is running and the Support Recovery option is on, the database is in ARCHIVELOG mode. If the database is running and the Support Recovery option is off, the database is in NOARCHIVELOG mode. The Backup Manager, when opened, appears in one of two ways, depending upon the status of the database:

running in ARCHIVELOG mode

running in NOARCHIVELOG mode or not running

During the backup process, you may be prompted to enter your database password. If so, enter your database password and select OK.

Backup Manager dialog box when the database is running and operating in ARCHIVELOG mode

Dialog Box Options

Database Status

Indicates the status of the database.

Offline - Full Database

If selected, shuts down the database and performs a full database backup. If the database was running before the backup, the Backup Manager restarts the database once the backup is complete. Full database backup includes all the data files, all online redo log files, and one copy of the control file.

Online - Selected Tablespace

If selected, backs up the selected tablespace.

Online - Control File only

If selected, backs up only one copy of the control files.

Tape

If selected, the backup is stored to tape.

Device

Indicates the tape device that stores the backup.

Disk, Directory, and Browse

If selected, the backup file is stored to the directory specified in the Directory field. Oracle recommends that you specify the complete path. You can use the associated Browse button to select where you want the backup file to be stored.

Backup

Initiates the backup procedure.

Backup Manager dialog box when the database is running in NOARCHIVELOG mode or is not running

Dialog Box Options

Database Status

Indicates the status of the database, either running in NOARCHIVELOG mode, or not running.

Backup Type

Indicates that the only type of backup possible is offline full backup.

Tape

If selected, the backup will be stored to tape.

Device

Indicates the tape device that will store the backup.

Disk, Directory, and Browse

If selected, the backup file is stored to the directory specified in the Directory field. Oracle recommends that you specify the complete path. You can use the associated Browse button to select where you want the backup file to be stored.

Backup

Initiates the backup procedure.

Files

Displays the Database Files dialog box, where you can review or modify the database files according to the current database structure. These include data files, online redo log files, and control files. (The Files button is only enabled when the database is not running.)

When the database is not running, the Files button is enabled. Since the database is not running, detailed information about the database structure is probably not available. However, accurate information is available if you have previously used the Backup Manager or Recovery Manager while the database was running. When the database is running, the Backup Manager reads and stores the structure of the database.

If the database is not running and you have not previously used Backup Manager with the database running, Backup Manager reads the database default values to determine the structure of the database.

Oracle recommends that you use the Files button to review the database files before performing a backup.


Control File Recovery dialog box

Dialog Box Options

Restore From Tape

If selected, the database is restored from files contained on the tape listed in the Device dropdown list box.

Device

The tape device.

Restore From Disk

If selected, the database is restored from files contained in the directory listed in the Directory dropdown list box.

Directory

Indicates the directory where the backup files are stored.

Browse

Opens the Restoration Source dialog.

Create A New Control File

If selected, Recovery Manager creates a new control file as part of the recovery process. Use this option if a backup control file is not available.

Backup

Lists all backup files located in the currently selected directory or tape. Each backup is listed as "<latest backup>" or by date and time.


Database Password Required dialog box

The Database Password Required dialog box appears only when the function you are requesting is restricted by a database password. This dialog prompts you for the database password.

When you enter the correct password and choose OK, you gain access to the restricted administrative functions of the database.


Database Files dialog box

Dialog Box Options

Data Files

If selected, the File List displays the list of data files on your database.

Log Files

If selected, the File List displays the list of log files and their group number associated with your database.

Control Files

If selected, the File List displays the list of control files on your database.

File List

Displays the valid list of files, depending upon whether Data, Log, or Control Files is selected.

Filename box

Enter a path and filename for a file you want to add to the list of files on your database.

Add

Adds the specified file in the Filename box to the File List.

Remove

Removes the selected file from the File List.

Group Number

Enabled only when the Log Files option is selected. This indicates the log file group sequence to which the currently selected log file belongs.


Data File Recovery dialog box

Dialog Box Options

Restore From Tape

If selected, the database is restored from files contained on the tape listed in the Device dropdown list box.

Device

The tape device.

Restore From Disk

If selected, the database is restored from files contained in the directory listed in the Directory dropdown list box.

Directory

Indicates the directory where the backup files are stored.

Browse

Opens the Restoration Source dialog.

Create A New Data File

If selected, Recovery Manager creates a new empty data file during recovery process. Use this option if no data file backup exists.

Backup

Lists all backup files located in the currently selected directory or tape. Each backup is listed as "<latest backup>" or by date and time.


Edit Database Parameters dialog box

Dialog Box Options

Parameter

Select the parameter you want to modify.

Value

Enter the new value of the parameter you are modifying.

Set Values

Displays the parameters you have modified and their current values. You can select multiple parameters, for example, to unset them. Double-clicking on an item in this list places the parameter and its value in their respective Parameter and Value text boxes.

Lookup

Choose Lookup to see the most recently set value for the selected parameter.

Set

Choose Set to add the selected parameter and its new value to the Set Values box.

Unset

Choose Unset to remove the selected parameter from the Set Values box.


Full Database Restoration dialog box

Dialog Box Options

Restore From Tape

If selected, the database is restored from files contained on the tape listed in the Device dropdown list box.

Device

The tape device.

Restore From Disk

If selected, the database is restored from files contained in the directory listed in the Directory dropdown list box.

Directory

Indicates the directory where the backup files are stored.

Browse

Opens the Restoration Source dialog.

Backup

Lists all backup files located in the currently selected directory or tape. Each backup is listed as "<latest backup>" or by date and time.


Recovery Manager dialog box

Use the Recovery Manager to recover your Oracle7 database after a failure.

During the Recovery process, you may be prompted to enter your database password. If so, enter your database password and select OK.

Additional Information: For more information about recovery, see Recovering A Database, in the Oracle7 Server Administrator's Guide.

Dialog Box Options

Automatic Recovery

Performs an automatic recovery.

Restore From Full Database Backup

Restores the database from a full database backup file.

Restore Data, then Do Recovery

Restores the selected data files and performs an automatic recovery.

Data file list box

Indicates the selected data file to restore.

Restore Control File, then Do Recovery

Restores the control file and performs an automatic recovery.

Recover

Initiates the recovery procedure.

Files...

Displays the Database Files dialog box. This button is only enabled if the database is not running at the time you open the Recovery Manager. Use this button to review or edit the file list according to the current database structure.

Parameters

Only enabled if the database is not running. Use this button to review or edit the initialization parameters to be used during the recovery process.